Overview
Brought to you by YData
Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 1000000 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 50009 |
| Duplicate rows (%) | 5.0% |
| Total size in memory | 491.5 MiB |
| Average record size in memory | 515.4 B |
Variable types
| Categorical | 4 |
|---|---|
| Text | 1 |
| DateTime | 2 |
| Numeric | 7 |
| Dataset has 50009 (5.0%) duplicate rows | Duplicates |
Item Type is highly overall correlated with Unit Cost and 1 other fields | High correlation |
Total Cost is highly overall correlated with Total Profit and 4 other fields | High correlation |
Total Profit is highly overall correlated with Total Cost and 4 other fields | High correlation |
Total Revenue is highly overall correlated with Total Cost and 4 other fields | High correlation |
Unit Cost is highly overall correlated with Item Type and 4 other fields | High correlation |
Unit Price is highly overall correlated with Item Type and 4 other fields | High correlation |
Units Sold is highly overall correlated with Total Cost and 2 other fields | High correlation |
Reproduction
| Analysis started | 2025-03-16 08:53:33.808812 |
|---|---|
| Analysis finished | 2025-03-16 08:55:03.202577 |
| Duration | 1 minute and 29.39 seconds |
| Software version | ydata-profiling vv4.14.0 |
| Download configuration | config.json |
Variables
Region
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.5 MiB |
| Sub-Saharan Africa | |
|---|---|
| Europe | |
| Asia | |
| Middle East and North Africa | |
| Central America and the Caribbean | |
| Other values (2) |
Length
| Max length | 33 |
|---|---|
| Median length | 28 |
| Mean length | 15.845056 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Sub-Saharan Africa |
|---|---|
| 2nd row | Middle East and North Africa |
| 3rd row | Australia and Oceania |
| 4th row | Sub-Saharan Africa |
| 5th row | Europe |
Common Values
| Value | Count | Frequency (%) |
| Sub-Saharan Africa | 259953 | |
| Europe | 259036 | |
| Asia | 146017 | |
| Middle East and North Africa | 124344 | |
| Central America and the Caribbean | 108042 | |
| Australia and Oceania | 80837 | 8.1% |
| North America | 21771 | 2.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| africa | 384297 | |
| and | 313223 | |
| sub-saharan | 259953 | |
| europe | 259036 | |
| north | 146115 | 6.2% |
| asia | 146017 | 6.2% |
| america | 129813 | 5.5% |
| middle | 124344 | 5.2% |
| east | 124344 | 5.2% |
| central | 108042 | 4.6% |
| Other values (4) | 377758 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 2525027 | |
| r | 1476135 | 9.3% |
| 1372942 | 8.7% | |
| i | 1054187 | 6.7% |
| e | 918156 | 5.8% |
| n | 870097 | 5.5% |
| A | 740964 | 4.7% |
| u | 599826 | 3.8% |
| c | 594947 | 3.8% |
| t | 567380 | 3.6% |
| Other values (16) | 5125395 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 15845056 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 2525027 | |
| r | 1476135 | 9.3% |
| 1372942 | 8.7% | |
| i | 1054187 | 6.7% |
| e | 918156 | 5.8% |
| n | 870097 | 5.5% |
| A | 740964 | 4.7% |
| u | 599826 | 3.8% |
| c | 594947 | 3.8% |
| t | 567380 | 3.6% |
| Other values (16) | 5125395 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 15845056 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 2525027 | |
| r | 1476135 | 9.3% |
| 1372942 | 8.7% | |
| i | 1054187 | 6.7% |
| e | 918156 | 5.8% |
| n | 870097 | 5.5% |
| A | 740964 | 4.7% |
| u | 599826 | 3.8% |
| c | 594947 | 3.8% |
| t | 567380 | 3.6% |
| Other values (16) | 5125395 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 15845056 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 2525027 | |
| r | 1476135 | 9.3% |
| 1372942 | 8.7% | |
| i | 1054187 | 6.7% |
| e | 918156 | 5.8% |
| n | 870097 | 5.5% |
| A | 740964 | 4.7% |
| u | 599826 | 3.8% |
| c | 594947 | 3.8% |
| t | 567380 | 3.6% |
| Other values (16) | 5125395 |
Country
Text
| Distinct | 185 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 62.9 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 22 |
| Mean length | 8.90437 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | South Africa |
|---|---|
| 2nd row | Morocco |
| 3rd row | Papua New Guinea |
| 4th row | Djibouti |
| 5th row | Slovakia |
| Value | Count | Frequency (%) |
| and | 32435 | 2.4% |
| republic | 27164 | 2.1% |
| the | 27042 | 2.0% |
| of | 21727 | 1.6% |
| saint | 16247 | 1.2% |
| guinea | 16235 | 1.2% |
| south | 16216 | 1.2% |
| united | 16202 | 1.2% |
| states | 10901 | 0.8% |
| new | 10893 | 0.8% |
| Other values (205) | 1129873 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1346140 | |
| i | 773466 | 8.7% |
| n | 702943 | 7.9% |
| e | 622961 | 7.0% |
| o | 486201 | 5.5% |
| r | 470532 | 5.3% |
| t | 367724 | 4.1% |
| 362809 | 4.1% | |
| u | 312437 | 3.5% |
| l | 292114 | 3.3% |
| Other values (43) | 3167043 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8904370 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 1346140 | |
| i | 773466 | 8.7% |
| n | 702943 | 7.9% |
| e | 622961 | 7.0% |
| o | 486201 | 5.5% |
| r | 470532 | 5.3% |
| t | 367724 | 4.1% |
| 362809 | 4.1% | |
| u | 312437 | 3.5% |
| l | 292114 | 3.3% |
| Other values (43) | 3167043 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8904370 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 1346140 | |
| i | 773466 | 8.7% |
| n | 702943 | 7.9% |
| e | 622961 | 7.0% |
| o | 486201 | 5.5% |
| r | 470532 | 5.3% |
| t | 367724 | 4.1% |
| 362809 | 4.1% | |
| u | 312437 | 3.5% |
| l | 292114 | 3.3% |
| Other values (43) | 3167043 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8904370 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 1346140 | |
| i | 773466 | 8.7% |
| n | 702943 | 7.9% |
| e | 622961 | 7.0% |
| o | 486201 | 5.5% |
| r | 470532 | 5.3% |
| t | 367724 | 4.1% |
| 362809 | 4.1% | |
| u | 312437 | 3.5% |
| l | 292114 | 3.3% |
| Other values (43) | 3167043 |
Item Type
Categorical
High correlation 
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 62.5 MiB |
| Fruits | |
|---|---|
| Personal Care | |
| Snacks | |
| Cosmetics | |
| Baby Food | |
| Other values (7) |
Length
| Max length | 15 |
|---|---|
| Median length | 13 |
| Mean length | 8.583558 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Fruits |
|---|---|
| 2nd row | Clothes |
| 3rd row | Meat |
| 4th row | Clothes |
| 5th row | Beverages |
Common Values
| Value | Count | Frequency (%) |
| Fruits | 83551 | |
| Personal Care | 83539 | |
| Snacks | 83448 | |
| Cosmetics | 83431 | |
| Baby Food | 83397 | |
| Beverages | 83326 | |
| Household | 83267 | |
| Clothes | 83240 | |
| Office Supplies | 83222 | |
| Cereal | 83211 | |
| Other values (2) | 166368 |
Length
| Value | Count | Frequency (%) |
| fruits | 83551 | 6.7% |
| personal | 83539 | 6.7% |
| care | 83539 | 6.7% |
| snacks | 83448 | 6.7% |
| cosmetics | 83431 | 6.7% |
| baby | 83397 | 6.7% |
| food | 83397 | 6.7% |
| beverages | 83326 | 6.7% |
| household | 83267 | 6.7% |
| clothes | 83240 | 6.7% |
| Other values (5) | 416023 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1332568 | |
| s | 833625 | 9.7% |
| a | 666828 | 7.8% |
| o | 583538 | 6.8% |
| l | 499649 | 5.8% |
| r | 417166 | 4.9% |
| t | 416590 | 4.9% |
| i | 333426 | 3.9% |
| C | 333421 | 3.9% |
| 250158 | 2.9% | |
| Other values (21) | 2916589 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8583558 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 1332568 | |
| s | 833625 | 9.7% |
| a | 666828 | 7.8% |
| o | 583538 | 6.8% |
| l | 499649 | 5.8% |
| r | 417166 | 4.9% |
| t | 416590 | 4.9% |
| i | 333426 | 3.9% |
| C | 333421 | 3.9% |
| 250158 | 2.9% | |
| Other values (21) | 2916589 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8583558 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 1332568 | |
| s | 833625 | 9.7% |
| a | 666828 | 7.8% |
| o | 583538 | 6.8% |
| l | 499649 | 5.8% |
| r | 417166 | 4.9% |
| t | 416590 | 4.9% |
| i | 333426 | 3.9% |
| C | 333421 | 3.9% |
| 250158 | 2.9% | |
| Other values (21) | 2916589 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8583558 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 1332568 | |
| s | 833625 | 9.7% |
| a | 666828 | 7.8% |
| o | 583538 | 6.8% |
| l | 499649 | 5.8% |
| r | 417166 | 4.9% |
| t | 416590 | 4.9% |
| i | 333426 | 3.9% |
| C | 333421 | 3.9% |
| 250158 | 2.9% | |
| Other values (21) | 2916589 |
Sales Channel
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 60.6 MiB |
| Offline | |
|---|---|
| Online |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.500249 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Offline |
|---|---|
| 2nd row | Online |
| 3rd row | Offline |
| 4th row | Offline |
| 5th row | Offline |
Common Values
| Value | Count | Frequency (%) |
| Offline | 500249 | |
| Online | 499751 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| offline | 500249 | |
| online | 499751 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 1499751 | |
| f | 1000498 | |
| O | 1000000 | |
| l | 1000000 | |
| i | 1000000 | |
| e | 1000000 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6500249 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 1499751 | |
| f | 1000498 | |
| O | 1000000 | |
| l | 1000000 | |
| i | 1000000 | |
| e | 1000000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6500249 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 1499751 | |
| f | 1000498 | |
| O | 1000000 | |
| l | 1000000 | |
| i | 1000000 | |
| e | 1000000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6500249 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 1499751 | |
| f | 1000498 | |
| O | 1000000 | |
| l | 1000000 | |
| i | 1000000 | |
| e | 1000000 |
Order Priority
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.3 MiB |
| C | |
|---|---|
| L | |
| H | |
| M |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | M |
| 4th row | H |
| 5th row | L |
Common Values
| Value | Count | Frequency (%) |
| C | 250313 | |
| L | 250133 | |
| H | 249861 | |
| M | 249693 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| c | 250313 | |
| l | 250133 | |
| h | 249861 | |
| m | 249693 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 250313 | |
| L | 250133 | |
| H | 249861 | |
| M | 249693 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1000000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 250313 | |
| L | 250133 | |
| H | 249861 | |
| M | 249693 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1000000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 250313 | |
| L | 250133 | |
| H | 249861 | |
| M | 249693 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1000000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 250313 | |
| L | 250133 | |
| H | 249861 | |
| M | 249693 |
Order Date
Date
| Distinct | 2767 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.6 MiB |
| Minimum | 2010-01-01 00:00:00 |
|---|---|
| Maximum | 2017-12-07 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Order ID
Real number (ℝ)
| Distinct | 900000 |
|---|---|
| Distinct (%) | 90.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.4935202 × 108 |
| Minimum | 1.0000118 × 108 |
|---|---|
| Maximum | 9.9999989 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.6 MiB |
Quantile statistics
| Minimum | 1.0000118 × 108 |
|---|---|
| 5-th percentile | 1.4472066 × 108 |
| Q1 | 3.2396295 × 108 |
| median | 5.4865235 × 108 |
| Q3 | 7.745981 × 108 |
| 95-th percentile | 9.5535643 × 108 |
| Maximum | 9.9999989 × 108 |
| Range | 8.9999871 × 108 |
| Interquartile range (IQR) | 4.5063515 × 108 |
Descriptive statistics
| Standard deviation | 2.599397 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.47317511 |
| Kurtosis | -1.2001336 |
| Mean | 5.4935202 × 108 |
| Median Absolute Deviation (MAD) | 2.252914 × 108 |
| Skewness | 0.004494625 |
| Sum | 5.4935202 × 1014 |
| Variance | 6.7568648 × 1016 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 673456180 | 2 | < 0.1% |
| 370419776 | 2 | < 0.1% |
| 847769296 | 2 | < 0.1% |
| 474296367 | 2 | < 0.1% |
| 667237317 | 2 | < 0.1% |
| 214140975 | 2 | < 0.1% |
| 222868669 | 2 | < 0.1% |
| 971594226 | 2 | < 0.1% |
| 558803975 | 2 | < 0.1% |
| 753296744 | 2 | < 0.1% |
| Other values (899990) | 999980 |
| Value | Count | Frequency (%) |
| 100001180 | 1 | |
| 100002467 | 1 | |
| 100002896 | 1 | |
| 100005042 | 1 | |
| 100007617 | 1 | |
| 100008904 | 1 | |
| 100009763 | 1 | |
| 100010192 | 1 | |
| 100011050 | 1 | |
| 100012767 | 1 |
| Value | Count | Frequency (%) |
| 999999892 | 1 | |
| 999999463 | 1 | |
| 999998605 | 1 | |
| 999996888 | 1 | |
| 999996459 | 1 | |
| 999996030 | 2 | |
| 999993884 | 1 | |
| 999992597 | 1 | |
| 999992167 | 2 | |
| 999991738 | 2 |
Ship Date
Date
| Distinct | 2817 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.6 MiB |
| Minimum | 2010-01-01 00:00:00 |
|---|---|
| Maximum | 2017-09-17 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Units Sold
Real number (ℝ)
High correlation 
| Distinct | 10000 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4998.8673 |
| Minimum | 1 |
|---|---|
| Maximum | 10000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 499 |
| Q1 | 2502 |
| median | 4998 |
| Q3 | 7496 |
| 95-th percentile | 9497 |
| Maximum | 10000 |
| Range | 9999 |
| Interquartile range (IQR) | 4994 |
Descriptive statistics
| Standard deviation | 2885.3341 |
|---|---|
| Coefficient of variation (CV) | 0.57719759 |
| Kurtosis | -1.1990497 |
| Mean | 4998.8673 |
| Median Absolute Deviation (MAD) | 2497 |
| Skewness | -0.00025107145 |
| Sum | 4.9988673 × 109 |
| Variance | 8325153.1 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8959 | 130 | < 0.1% |
| 7228 | 129 | < 0.1% |
| 187 | 129 | < 0.1% |
| 5170 | 129 | < 0.1% |
| 1826 | 129 | < 0.1% |
| 3258 | 129 | < 0.1% |
| 7632 | 128 | < 0.1% |
| 9019 | 128 | < 0.1% |
| 9764 | 128 | < 0.1% |
| 3065 | 128 | < 0.1% |
| Other values (9990) | 998713 |
| Value | Count | Frequency (%) |
| 1 | 101 | |
| 2 | 100 | |
| 3 | 93 | |
| 4 | 104 | |
| 5 | 94 | |
| 6 | 100 | |
| 7 | 114 | |
| 8 | 94 | |
| 9 | 111 | |
| 10 | 97 |
| Value | Count | Frequency (%) |
| 10000 | 95 | |
| 9999 | 107 | |
| 9998 | 92 | |
| 9997 | 100 | |
| 9996 | 92 | |
| 9995 | 99 | |
| 9994 | 107 | |
| 9993 | 110 | |
| 9992 | 89 | |
| 9991 | 103 |
Unit Price
Real number (ℝ)
High correlation 
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 266.02549 |
| Minimum | 9.33 |
|---|---|
| Maximum | 668.27 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.6 MiB |
Quantile statistics
| Minimum | 9.33 |
|---|---|
| 5-th percentile | 9.33 |
| Q1 | 81.73 |
| median | 154.06 |
| Q3 | 421.89 |
| 95-th percentile | 668.27 |
| Maximum | 668.27 |
| Range | 658.94 |
| Interquartile range (IQR) | 340.16 |
Descriptive statistics
| Standard deviation | 216.98797 |
|---|---|
| Coefficient of variation (CV) | 0.81566607 |
| Kurtosis | -0.80766595 |
| Mean | 266.02549 |
| Median Absolute Deviation (MAD) | 101.22 |
| Skewness | 0.73655188 |
| Sum | 2.6602549 × 108 |
| Variance | 47083.777 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9.33 | 83551 | |
| 81.73 | 83539 | |
| 152.58 | 83448 | |
| 437.2 | 83431 | |
| 255.28 | 83397 | |
| 47.45 | 83326 | |
| 668.27 | 83267 | |
| 109.28 | 83240 | |
| 651.21 | 83222 | |
| 205.7 | 83211 | |
| Other values (2) | 166368 |
| Value | Count | Frequency (%) |
| 9.33 | 83551 | |
| 47.45 | 83326 | |
| 81.73 | 83539 | |
| 109.28 | 83240 | |
| 152.58 | 83448 | |
| 154.06 | 83170 | |
| 205.7 | 83211 | |
| 255.28 | 83397 | |
| 421.89 | 83198 | |
| 437.2 | 83431 |
| Value | Count | Frequency (%) |
| 668.27 | 83267 | |
| 651.21 | 83222 | |
| 437.2 | 83431 | |
| 421.89 | 83198 | |
| 255.28 | 83397 | |
| 205.7 | 83211 | |
| 154.06 | 83170 | |
| 152.58 | 83448 | |
| 109.28 | 83240 | |
| 81.73 | 83539 |
Unit Cost
Real number (ℝ)
High correlation 
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 187.52298 |
| Minimum | 6.92 |
|---|---|
| Maximum | 524.96 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.6 MiB |
Quantile statistics
| Minimum | 6.92 |
|---|---|
| 5-th percentile | 6.92 |
| Q1 | 35.84 |
| median | 97.44 |
| Q3 | 263.33 |
| 95-th percentile | 524.96 |
| Maximum | 524.96 |
| Range | 518.04 |
| Interquartile range (IQR) | 227.49 |
Descriptive statistics
| Standard deviation | 175.6508 |
|---|---|
| Coefficient of variation (CV) | 0.93668947 |
| Kurtosis | -0.68364978 |
| Mean | 187.52298 |
| Median Absolute Deviation (MAD) | 61.98 |
| Skewness | 0.89459132 |
| Sum | 1.8752298 × 108 |
| Variance | 30853.203 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6.92 | 83551 | |
| 56.67 | 83539 | |
| 97.44 | 83448 | |
| 263.33 | 83431 | |
| 159.42 | 83397 | |
| 31.79 | 83326 | |
| 502.54 | 83267 | |
| 35.84 | 83240 | |
| 524.96 | 83222 | |
| 117.11 | 83211 | |
| Other values (2) | 166368 |
| Value | Count | Frequency (%) |
| 6.92 | 83551 | |
| 31.79 | 83326 | |
| 35.84 | 83240 | |
| 56.67 | 83539 | |
| 90.93 | 83170 | |
| 97.44 | 83448 | |
| 117.11 | 83211 | |
| 159.42 | 83397 | |
| 263.33 | 83431 | |
| 364.69 | 83198 |
| Value | Count | Frequency (%) |
| 524.96 | 83222 | |
| 502.54 | 83267 | |
| 364.69 | 83198 | |
| 263.33 | 83431 | |
| 159.42 | 83397 | |
| 117.11 | 83211 | |
| 97.44 | 83448 | |
| 90.93 | 83170 | |
| 56.67 | 83539 | |
| 35.84 | 83240 |
Total Revenue
Real number (ℝ)
High correlation 
| Distinct | 119901 |
|---|---|
| Distinct (%) | 12.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1329562.6 |
| Minimum | 9.33 |
|---|---|
| Maximum | 6682700 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.6 MiB |
Quantile statistics
| Minimum | 9.33 |
|---|---|
| 5-th percentile | 33476.04 |
| Q1 | 277867.2 |
| median | 784444.54 |
| Q3 | 1822443.9 |
| 95-th percentile | 4607053.4 |
| Maximum | 6682700 |
| Range | 6682690.7 |
| Interquartile range (IQR) | 1544576.7 |
Descriptive statistics
| Standard deviation | 1468527.3 |
|---|---|
| Coefficient of variation (CV) | 1.1045191 |
| Kurtosis | 1.9386254 |
| Mean | 1329562.6 |
| Median Absolute Deviation (MAD) | 623339.46 |
| Skewness | 1.5797682 |
| Sum | 1.3295626 × 1012 |
| Variance | 2.1565725 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2990356.32 | 24 | < 0.1% |
| 808606.7 | 23 | < 0.1% |
| 152835.1 | 23 | < 0.1% |
| 69844.38 | 21 | < 0.1% |
| 1868972.7 | 21 | < 0.1% |
| 368449.25 | 21 | < 0.1% |
| 1738744.4 | 20 | < 0.1% |
| 1854602.4 | 20 | < 0.1% |
| 414902.8 | 20 | < 0.1% |
| 960207.6 | 20 | < 0.1% |
| Other values (119891) | 999787 |
| Value | Count | Frequency (%) |
| 9.33 | 13 | |
| 18.66 | 14 | |
| 27.99 | 9 | |
| 37.32 | 8 | |
| 46.65 | 9 | |
| 47.45 | 10 | |
| 55.98 | 13 | |
| 65.31 | 16 | |
| 74.64 | 5 | < 0.1% |
| 81.73 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 6682700 | 8 | |
| 6682031.73 | 7 | |
| 6681363.46 | 6 | |
| 6680695.19 | 6 | |
| 6680026.92 | 9 | |
| 6679358.65 | 10 | |
| 6678690.38 | 10 | |
| 6678022.11 | 11 | |
| 6677353.84 | 4 | < 0.1% |
| 6676685.57 | 7 |
Total Cost
Real number (ℝ)
High correlation 
| Distinct | 119734 |
|---|---|
| Distinct (%) | 12.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 937267.09 |
| Minimum | 6.92 |
|---|---|
| Maximum | 5249600 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.6 MiB |
Quantile statistics
| Minimum | 6.92 |
|---|---|
| 5-th percentile | 22400 |
| Q1 | 161728.91 |
| median | 466781.76 |
| Q3 | 1196327.1 |
| 95-th percentile | 3612249.8 |
| Maximum | 5249600 |
| Range | 5249593.1 |
| Interquartile range (IQR) | 1034598.2 |
Descriptive statistics
| Standard deviation | 1148954.3 |
|---|---|
| Coefficient of variation (CV) | 1.2258558 |
| Kurtosis | 2.4179065 |
| Mean | 937267.09 |
| Median Absolute Deviation (MAD) | 387535.96 |
| Skewness | 1.7495362 |
| Sum | 9.3726709 × 1011 |
| Variance | 1.3200959 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24801.28 | 28 | < 0.1% |
| 305571.84 | 27 | < 0.1% |
| 98167.52 | 26 | < 0.1% |
| 18600.96 | 26 | < 0.1% |
| 230737.92 | 26 | < 0.1% |
| 243210.24 | 26 | < 0.1% |
| 46556.16 | 25 | < 0.1% |
| 118487.04 | 25 | < 0.1% |
| 456377.67 | 25 | < 0.1% |
| 87306.24 | 24 | < 0.1% |
| Other values (119724) | 999742 |
| Value | Count | Frequency (%) |
| 6.92 | 13 | |
| 13.84 | 14 | |
| 20.76 | 9 | |
| 27.68 | 8 | |
| 31.79 | 10 | |
| 34.6 | 9 | |
| 35.84 | 7 | |
| 41.52 | 13 | |
| 48.44 | 16 | |
| 55.36 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 5249600 | 10 | |
| 5249075.04 | 8 | |
| 5248550.08 | 10 | |
| 5248025.12 | 9 | |
| 5247500.16 | 12 | |
| 5246975.2 | 9 | |
| 5246450.24 | 7 | |
| 5245925.28 | 8 | |
| 5245400.32 | 4 | < 0.1% |
| 5244875.36 | 11 |
Total Profit
Real number (ℝ)
High correlation 
| Distinct | 119779 |
|---|---|
| Distinct (%) | 12.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 392295.56 |
| Minimum | 2.41 |
|---|---|
| Maximum | 1738700 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.6 MiB |
Quantile statistics
| Minimum | 2.41 |
|---|---|
| 5-th percentile | 9570.11 |
| Q1 | 95104.8 |
| median | 281054.88 |
| Q3 | 565307.6 |
| 95-th percentile | 1217050 |
| Maximum | 1738700 |
| Range | 1738697.6 |
| Interquartile range (IQR) | 470202.8 |
Descriptive statistics
| Standard deviation | 378819.9 |
|---|---|
| Coefficient of variation (CV) | 0.96564922 |
| Kurtosis | 1.2660055 |
| Mean | 392295.56 |
| Median Absolute Deviation (MAD) | 218301.12 |
| Skewness | 1.2949991 |
| Sum | 3.9229556 × 1011 |
| Variance | 1.4350452 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 66022.56 | 25 | < 0.1% |
| 105019.2 | 24 | < 0.1% |
| 14391.54 | 23 | < 0.1% |
| 433736.64 | 23 | < 0.1% |
| 472439.52 | 23 | < 0.1% |
| 12078.92 | 23 | < 0.1% |
| 86349.24 | 23 | < 0.1% |
| 849223.74 | 23 | < 0.1% |
| 140564.16 | 22 | < 0.1% |
| 48984.48 | 22 | < 0.1% |
| Other values (119769) | 999769 |
| Value | Count | Frequency (%) |
| 2.41 | 13 | |
| 4.82 | 14 | |
| 7.23 | 9 | |
| 9.64 | 8 | |
| 12.05 | 9 | |
| 14.46 | 13 | |
| 15.66 | 10 | |
| 16.87 | 16 | |
| 19.28 | 5 | < 0.1% |
| 21.69 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 1738700 | 10 | |
| 1738526.13 | 6 | |
| 1738352.26 | 8 | |
| 1738178.39 | 4 | < 0.1% |
| 1738004.52 | 4 | < 0.1% |
| 1737830.65 | 3 | < 0.1% |
| 1737656.78 | 8 | |
| 1737482.91 | 12 | |
| 1737309.04 | 8 | |
| 1737135.17 | 6 |
Interactions
Correlations
| Item Type | Order ID | Order Priority | Region | Sales Channel | Total Cost | Total Profit | Total Revenue | Unit Cost | Unit Price | Units Sold | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Item Type | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.355 | 0.322 | 0.334 | 1.000 | 1.000 | 0.000 |
| Order ID | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | -0.000 | -0.000 | -0.000 | -0.000 | -0.000 | -0.000 |
| Order Priority | 0.000 | 0.000 | 1.000 | 0.000 | 0.001 | 0.001 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| Region | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.001 |
| Sales Channel | 0.000 | 0.000 | 0.001 | 0.000 | 1.000 | 0.001 | 0.002 | 0.003 | 0.000 | 0.000 | 0.000 |
| Total Cost | 0.355 | -0.000 | 0.001 | 0.000 | 0.001 | 1.000 | 0.884 | 0.988 | 0.793 | 0.778 | 0.536 |
| Total Profit | 0.322 | -0.000 | 0.000 | 0.000 | 0.002 | 0.884 | 1.000 | 0.940 | 0.600 | 0.655 | 0.621 |
| Total Revenue | 0.334 | -0.000 | 0.000 | 0.000 | 0.003 | 0.988 | 0.940 | 1.000 | 0.752 | 0.759 | 0.573 |
| Unit Cost | 1.000 | -0.000 | 0.000 | 0.000 | 0.000 | 0.793 | 0.600 | 0.752 | 1.000 | 0.972 | -0.001 |
| Unit Price | 1.000 | -0.000 | 0.000 | 0.000 | 0.000 | 0.778 | 0.655 | 0.759 | 0.972 | 1.000 | -0.001 |
| Units Sold | 0.000 | -0.000 | 0.000 | 0.001 | 0.000 | 0.536 | 0.621 | 0.573 | -0.001 | -0.001 | 1.000 |
Missing values
Sample
| Region | Country | Item Type | Sales Channel | Order Priority | Order Date | Order ID | Ship Date | Units Sold | Unit Price | Unit Cost | Total Revenue | Total Cost | Total Profit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Sub-Saharan Africa | South Africa | Fruits | Offline | M | 27-07-2012 | 443368995 | 7/28/2012 | 1593 | 9.33 | 6.92 | 14862.69 | 11023.56 | 3839.13 |
| 1 | Middle East and North Africa | Morocco | Clothes | Online | M | 14-09-2013 | 667593514 | 10/19/2013 | 4611 | 109.28 | 35.84 | 503890.08 | 165258.24 | 338631.84 |
| 2 | Australia and Oceania | Papua New Guinea | Meat | Offline | M | 15-05-2015 | 940995585 | 06-04-2015 | 360 | 421.89 | 364.69 | 151880.40 | 131288.40 | 20592.00 |
| 3 | Sub-Saharan Africa | Djibouti | Clothes | Offline | H | 17-05-2017 | 880811536 | 07-02-2017 | 562 | 109.28 | 35.84 | 61415.36 | 20142.08 | 41273.28 |
| 4 | Europe | Slovakia | Beverages | Offline | L | 26-10-2016 | 174590194 | 12-04-2016 | 3973 | 47.45 | 31.79 | 188518.85 | 126301.67 | 62217.18 |
| 5 | Asia | Sri Lanka | Fruits | Online | L | 07-11-2011 | 830192887 | 12/18/2011 | 1379 | 9.33 | 6.92 | 12866.07 | 9542.68 | 3323.39 |
| 6 | Sub-Saharan Africa | Seychelles | Beverages | Online | M | 18-01-2013 | 425793445 | 2/16/2013 | 597 | 47.45 | 31.79 | 28327.65 | 18978.63 | 9349.02 |
| 7 | Sub-Saharan Africa | Tanzania | Beverages | Online | L | 30-11-2016 | 659878194 | 1/16/2017 | 1476 | 47.45 | 31.79 | 70036.20 | 46922.04 | 23114.16 |
| 8 | Sub-Saharan Africa | Ghana | Office Supplies | Online | L | 23-03-2017 | 601245963 | 4/15/2017 | 896 | 651.21 | 524.96 | 583484.16 | 470364.16 | 113120.00 |
| 9 | Sub-Saharan Africa | Tanzania | Cosmetics | Offline | L | 23-05-2016 | 739008080 | 5/24/2016 | 7768 | 437.20 | 263.33 | 3396169.60 | 2045547.44 | 1350622.16 |
| Region | Country | Item Type | Sales Channel | Order Priority | Order Date | Order ID | Ship Date | Units Sold | Unit Price | Unit Cost | Total Revenue | Total Cost | Total Profit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 999990 | Sub-Saharan Africa | Zimbabwe | Meat | Online | C | 23-02-2010 | 497280108 | 3/23/2010 | 5090 | 421.89 | 364.69 | 2147420.10 | 1856272.10 | 291148.00 |
| 999991 | Europe | Netherlands | Fruits | Offline | C | 28-08-2014 | 277629506 | 09-05-2014 | 5595 | 9.33 | 6.92 | 52201.35 | 38717.40 | 13483.95 |
| 999992 | Middle East and North Africa | Iran | Personal Care | Online | H | 27-08-2013 | 461355674 | 9/28/2013 | 4251 | 81.73 | 56.67 | 347434.23 | 240904.17 | 106530.06 |
| 999993 | Europe | Armenia | Personal Care | Offline | C | 28-03-2015 | 412569940 | 4/26/2015 | 7468 | 81.73 | 56.67 | 610359.64 | 423211.56 | 187148.08 |
| 999994 | Europe | Germany | Office Supplies | Online | C | 16-03-2017 | 465696132 | 04-04-2017 | 8689 | 651.21 | 524.96 | 5658363.69 | 4561377.44 | 1096986.25 |
| 999995 | Sub-Saharan Africa | Senegal | Baby Food | Offline | L | 06-11-2010 | 575470578 | 12-11-2010 | 3387 | 255.28 | 159.42 | 864633.36 | 539955.54 | 324677.82 |
| 999996 | Central America and the Caribbean | Panama | Office Supplies | Offline | C | 12-01-2015 | 766942107 | 03-01-2015 | 4068 | 651.21 | 524.96 | 2649122.28 | 2135537.28 | 513585.00 |
| 999997 | Europe | Norway | Office Supplies | Online | M | 25-10-2011 | 685472047 | 12-05-2011 | 5266 | 651.21 | 524.96 | 3429271.86 | 2764439.36 | 664832.50 |
| 999998 | Europe | Montenegro | Beverages | Offline | M | 31-10-2010 | 946734225 | 12-08-2010 | 8551 | 47.45 | 31.79 | 405744.95 | 271836.29 | 133908.66 |
| 999999 | Central America and the Caribbean | Nicaragua | Meat | Online | C | 17-03-2015 | 886714971 | 04-08-2015 | 7519 | 421.89 | 364.69 | 3172190.91 | 2742104.11 | 430086.80 |
Duplicate rows
Most frequently occurring
| Region | Country | Item Type | Sales Channel | Order Priority | Order Date | Order ID | Ship Date | Units Sold | Unit Price | Unit Cost | Total Revenue | Total Cost | Total Profit | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Asia | Bangladesh | Baby Food | Offline | H | 12-05-2011 | 831867444 | 5/31/2011 | 6917 | 255.28 | 159.42 | 1765771.76 | 1102708.14 | 663063.62 | 2 |
| 1 | Asia | Bangladesh | Baby Food | Offline | H | 20-03-2010 | 411088502 | 4/17/2010 | 9078 | 255.28 | 159.42 | 2317431.84 | 1447214.76 | 870217.08 | 2 |
| 2 | Asia | Bangladesh | Baby Food | Offline | H | 23-04-2011 | 779794824 | 06-02-2011 | 7472 | 255.28 | 159.42 | 1907452.16 | 1191186.24 | 716265.92 | 2 |
| 3 | Asia | Bangladesh | Baby Food | Offline | L | 22-06-2014 | 597013223 | 07-04-2014 | 8334 | 255.28 | 159.42 | 2127503.52 | 1328606.28 | 798897.24 | 2 |
| 4 | Asia | Bangladesh | Baby Food | Offline | L | 24-11-2011 | 122104299 | 12/18/2011 | 2230 | 255.28 | 159.42 | 569274.40 | 355506.60 | 213767.80 | 2 |
| 5 | Asia | Bangladesh | Baby Food | Offline | M | 05-02-2014 | 847749555 | 02-06-2014 | 6787 | 255.28 | 159.42 | 1732585.36 | 1081983.54 | 650601.82 | 2 |
| 6 | Asia | Bangladesh | Baby Food | Offline | M | 12-04-2015 | 432368505 | 05-02-2015 | 6304 | 255.28 | 159.42 | 1609285.12 | 1004983.68 | 604301.44 | 2 |
| 7 | Asia | Bangladesh | Baby Food | Offline | M | 16-03-2014 | 951894795 | 3/26/2014 | 5678 | 255.28 | 159.42 | 1449479.84 | 905186.76 | 544293.08 | 2 |
| 8 | Asia | Bangladesh | Baby Food | Offline | M | 30-03-2015 | 368528497 | 05-12-2015 | 4627 | 255.28 | 159.42 | 1181180.56 | 737636.34 | 443544.22 | 2 |
| 9 | Asia | Bangladesh | Baby Food | Online | C | 03-04-2012 | 695760571 | 4/14/2012 | 9869 | 255.28 | 159.42 | 2519358.32 | 1573315.98 | 946042.34 | 2 |